0
  1. My Store
  2. Search

Search Results for "lipton tchae the vert orient 25 sachets 44g lot de 3"

GUOQY-boîte de Cuisine de Famille de Coffret de thé de Couleur, boîte de Rangement Double de Couvercle de Cylindre, Coffre à café
GUOQY-boîte de Cuisine de Famille de Cof...
View to See Price
View
Add to Cart
Mariage Frères - GENMAÏCHA MATCHA ÉMERAUDE (NOUVEAU!!) - Boîte de 30 sachets mousseline de thé
Mariage Frères - GENMAÏCHA MATCHA ÉMERAU...
only €44,75
View
Add to Cart
Thé Shangri-La - Népal (Boîte 24 sachets)
Thé Shangri-La - Népal (Boîte 24 sachets...
only €9,95
View
Add to Cart
Premier Housewares Boîte à thé Liberty
Premier Housewares Boîte à thé Liberty...
from €11,79
View
Add to Cart
Thé Siberian Blend - Imperial Russian (Boîte 24 sachets)
Thé Siberian Blend - Imperial Russian (B...
only €9,95
View
Add to Cart
Yogi tea Thé Bio Rooibos 31 g - Pack de 6
Yogi tea Thé Bio Rooibos 31 g - Pack de ...
only €4,47
View
Add to Cart
500 g Thé Boîte de rangement hermétique Noir
500 g Thé Boîte de rangement hermétique ...
View to See Price
View
Add to Cart
Boîte à fenêtre café Gondole, Derrière La Porte
Boîte à fenêtre café Gondole, Derrière L...
View to See Price
View
Add to Cart
Dammann Frères - Thé Rooibos Citrus -100gr boite
Dammann Frères - Thé Rooibos Citrus -100...
only €19,85
View
Add to Cart
Løv Organic - Rooibos Verveine-Menthe - Boîte de 20 sachets
Løv Organic - Rooibos Verveine-Menthe - ...
View to See Price
View
Add to Cart
Boîte de conservation alimentaire en céramique avec couvercle hermétique en bambou - Design moderne en marbre - Pour servir du thé, du café, des épices et plus encore
Boîte de conservation alimentaire en cér...
View to See Price
View
Add to Cart
Thé Red Star - Boîte 24 sachets - BIO
Thé Red Star - Boîte 24 sachets - BIO
only €9,95
View
Add to Cart
Thé Rooibos Max Benjamin Bougie parfumée dans boîte en métal
Thé Rooibos Max Benjamin Bougie parfumée...
View to See Price
View
Add to Cart
Vivaraise Coussin Stonewash Swami Rooibos 45 x 45 cm
Vivaraise Coussin Stonewash Swami Rooibo...
only €32,90
View
Add to Cart
Mariage Frères - FRENCH BREAKFAST - Boîte de 30 sachets mousseline de thé
Mariage Frères - FRENCH BREAKFAST - Boît...
only €34,75
View
Add to Cart
Dammann Frères - Thé Rooibos VANILLE - 24 sachets individuels
Dammann Frères - Thé Rooibos VANILLE - 2...
only €19,95
View
Add to Cart
Clipper Amazing The Vert au Gingembre Bio 35 g
Clipper Amazing The Vert au Gingembre Bi...
only €2,80
View
Add to Cart
Thé Sun King - Royal Yuzu Earl Grey (Boîte 24 sachets)
Thé Sun King - Royal Yuzu Earl Grey (Boî...
only €9,95
View
Add to Cart

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5352718830109 393 1.1919 0


No Amazon API Requests Made.


App Debug - Total Time 1.5352718830109 seconds

Number Time From Start Name Description
1 0.33394384384155 Initialise Initialise FSB Function
2 0.33623886108398 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38925385475159 Start of getCategoryListByGroup Function Before first category groups query
4 0.38962292671204 After initial query Before first category groups query
5 0.38962292671204 Get Category List for Group Before the call to getCategoryList function
6 0.38962602615356 Start of GetCategoryList function Start of the function
7 0.3896279335022 Before getting categories Query to get specific category list
8 0.3899998664856 After getting categories Query to get specific category list
9 0.39000082015991 Before getting category custom Before call to function getCategoryCustom
10 0.40302991867065 After getting category custom After call to function getCategoryCustom
11 0.40303087234497 Before getting category custom Before call to function getCategoryCustom
12 0.41106796264648 After getting category custom After call to function getCategoryCustom
13 0.41106986999512 Before getting category custom Before call to function getCategoryCustom
14 0.41461896896362 After getting category custom After call to function getCategoryCustom
15 0.41461992263794 Before getting category custom Before call to function getCategoryCustom
16 0.41673588752747 After getting category custom After call to function getCategoryCustom
17 0.41673684120178 Before getting category custom Before call to function getCategoryCustom
18 0.41881799697876 After getting category custom After call to function getCategoryCustom
19 0.41881895065308 Before getting category custom Before call to function getCategoryCustom
20 0.42093896865845 After getting category custom After call to function getCategoryCustom
21 0.42093992233276 End of GetCategoryList function End of the function
22 0.42094397544861 Get Category List for Group Before the call to getCategoryList function
23 0.42094492912292 Start of GetCategoryList function Start of the function
24 0.42094588279724 Before getting categories Query to get specific category list
25 0.42120099067688 End of getCategoryListByGroup Function Before return()
26 1.3657698631287 App Controller End End of the App controller (called before the controller of every page)
27 1.4880969524384 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.4887239933014 Before Get Options Before the call to getOptions in the tpl class
29 1.5241990089417 After Get Options After the call to getOptions in the tpl class
30 1.5242450237274 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.5352628231049 Finalizing debug Before the debug is output to the page.
32 1.5352718830109 End of App This is the end of the app logging, final timestamp


Query Debug - 393 Database Queries. Total time 1.1919 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0009 0.00088095664978027 
SELECT parameter, value FROM parameters
2 0.0050 0.0050370693206787 
SELECT * FROM `bad_bots`
3 0.0003 0.0003049373626709 
SET time_zone = 'Europe/London'
4 0.0005 0.00054717063903809 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00056815147399902 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.99\";}'
6 0.0005 0.00054597854614258 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1757883064'
7 0.0007 0.00069499015808105 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0004 0.00043082237243652 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0011410713195801 
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10 0.0004 0.00036287307739258 
SELECT * FROM pages WHERE id = 52
11 0.0027 0.0027060508728027 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0489 0.048909902572632 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0010 0.00096702575683594 
SELECT * FROM pages WHERE pagename = 'search'
14 0.0004 0.00035881996154785 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00035905838012695 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0050 0.0049700736999512 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0009 0.00092697143554688 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0003 0.00031900405883789 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0003 0.00027298927307129 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0053 0.0053369998931885 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0003 0.00029492378234863 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0003 0.00028681755065918 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0003 0.00032615661621094 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00023889541625977 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0032 0.0031759738922119 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.00029897689819336 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0002 0.00020098686218262 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00020885467529297 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0032 0.003173828125 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0002 0.000244140625 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0002 0.00022697448730469 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0002 0.00023794174194336 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00023794174194336 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0010 0.0010230541229248 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0002 0.00022792816162109 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0002 0.00018596649169922 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00019979476928711 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0010 0.001039981842041 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0002 0.00020909309387207 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0002 0.00021004676818848 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0002 0.00022196769714355 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020694732666016 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00029611587524414 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0002 0.00023794174194336 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0002 0.00019502639770508 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00022101402282715 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00030994415283203 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0002 0.00020384788513184 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0002 0.00020694732666016 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0002 0.00022006034851074 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00020194053649902 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0003 0.00029087066650391 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0002 0.00023221969604492 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0002 0.00018596649169922 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00021195411682129 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0003 0.00030303001403809 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0002 0.00020289421081543 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0002 0.00020718574523926 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0002 0.0002291202545166 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00020194053649902 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0003 0.0003359317779541 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0002 0.00021791458129883 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0002 0.00018692016601562 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00020599365234375 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0003 0.0003211498260498 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0002 0.00020503997802734 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0002 0.00020718574523926 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0002 0.00022196769714355 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00019979476928711 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0003 0.00025105476379395 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0014 0.0013890266418457 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0004 0.00038909912109375 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00030183792114258 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0003 0.00027012825012207 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0008 0.00082612037658691 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00047492980957031 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.9381 0.93812394142151 
SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.99') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.99') <= INET_ATON(ip_end)
78 0.0015 0.0015270709991455 
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.00055885314941406 
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00062298774719238 
SELECT * FROM pages WHERE pagename = 'search'
81 0.0093 0.009343147277832 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0019 0.0019440650939941 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0006 0.00055289268493652 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84 0.0061 0.0061180591583252 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85 0.0020 0.0020449161529541 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86 0.0004 0.00042891502380371 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87 0.0003 0.00033807754516602 
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'lipton tchae the vert orient 25 sachets 44g lot de 3', NOW(), '216.73.216.99'
88 0.0004 0.00039005279541016 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
89 0.0004 0.00037193298339844 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
90 0.0053 0.0053269863128662 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'lipton') OR (keyfeatures LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (keyfeatures LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (keyfeatures LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (keyfeatures LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (keyfeatures LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (keyfeatures LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (keyfeatures LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (keyfeatures LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
91 0.0003 0.00029706954956055 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
92 0.0002 0.00022697448730469 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
93 0.0003 0.00032496452331543 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
94 0.0061 0.0061171054840088 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%lipton%') OR (keyfeatures LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (keyfeatures LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (keyfeatures LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (keyfeatures LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (keyfeatures LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (keyfeatures LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (keyfeatures LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (keyfeatures LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
95 0.0003 0.0002591609954834 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
96 0.0002 0.00024604797363281 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
97 0.0003 0.0003352165222168 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
98 0.0006 0.0005638599395752 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
99 0.0066 0.0066161155700684 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'lipton') OR (keyfeatures LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (keyfeatures LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (keyfeatures LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (keyfeatures LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (keyfeatures LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (keyfeatures LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (keyfeatures LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (keyfeatures LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0003 0.00028395652770996 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
101 0.0004 0.00036311149597168 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
102 0.0003 0.00033187866210938 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
103 0.0063 0.0062730312347412 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%lipton%') OR (keyfeatures LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (keyfeatures LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (keyfeatures LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (keyfeatures LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (keyfeatures LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (keyfeatures LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (keyfeatures LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (keyfeatures LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
104 0.0005 0.00046205520629883 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
105 0.0002 0.0002448558807373 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
106 0.0003 0.00029087066650391 
SELECT * FROM products WHERE id = '2689'
107 0.0004 0.00037217140197754 
SELECT * FROM productimages WHERE product_id = '2689' ORDER BY sortorder ASC
108 0.0004 0.00042200088500977 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2689' AND p.id = pi.product_id ORDER BY pi.sortorder
109 0.0011 0.0011451244354248 
SELECT * FROM product_image_select WHERE product_id = '2689'
110 0.0008 0.00082802772521973 
SELECT * FROM productcustomimages WHERE product_id = '2689'
111 0.0006 0.00055193901062012 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2689'
                GROUP BY o.product_id
112 0.0004 0.00037693977355957 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2689'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
113 0.0002 0.00024294853210449 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2689
114 0.0009 0.00085711479187012 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2689' AND a.name = n.originalname
115 0.0004 0.0003960132598877 
SELECT * FROM productoffers WHERE product_id = '2689' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0002 0.00024008750915527 
SELECT * FROM productoffers
                WHERE product_id = '2689' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0002 0.00023412704467773 
SELECT * FROM productoffers
                WHERE product_id = 2689
                ORDER BY price ASC LIMIT 1
118 0.0002 0.00024294853210449 
SELECT value FROM productattributes
                WHERE product_id = '2689'
                AND name = 'ListPriceAmount'
119 0.0003 0.00034689903259277 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2689'
                GROUP BY o.product_id
120 0.0003 0.00026416778564453 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2689'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
121 0.0002 0.00023412704467773 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2689
122 0.0003 0.00025701522827148 
SELECT value FROM productattributes WHERE product_id = '2689' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0003 0.0002741813659668 
SELECT * FROM products WHERE parent_id = '2689'
124 0.0002 0.00024318695068359 
SELECT * FROM products WHERE id = '1727'
125 0.0002 0.00022506713867188 
SELECT * FROM productimages WHERE product_id = '1727' ORDER BY sortorder ASC
126 0.0004 0.00038909912109375 
SELECT * FROM product_image_select WHERE product_id = '1727'
127 0.0002 0.00020313262939453 
SELECT * FROM productcustomimages WHERE product_id = '1727'
128 0.0004 0.0004420280456543 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1727' AND a.name = n.originalname
129 0.0003 0.00028705596923828 
SELECT * FROM productoffers WHERE product_id = '1727' AND merchantid = 'A1X6FK5RDHNB96'
130 0.0003 0.0003058910369873 
SELECT * FROM productoffers
                WHERE product_id = '1727' AND price > 0
                ORDER BY price ASC LIMIT 1
131 0.0003 0.00027179718017578 
SELECT value FROM productattributes WHERE product_id = '1727' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132 0.0003 0.00026917457580566 
SELECT * FROM products WHERE id = '1395'
133 0.0003 0.00026798248291016 
SELECT * FROM productimages WHERE product_id = '1395' ORDER BY sortorder ASC
134 0.0004 0.00038909912109375 
SELECT * FROM product_image_select WHERE product_id = '1395'
135 0.0002 0.00019693374633789 
SELECT * FROM productcustomimages WHERE product_id = '1395'
136 0.0006 0.00064992904663086 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1395' AND a.name = n.originalname
137 0.0003 0.00025200843811035 
SELECT * FROM productoffers WHERE product_id = '1395' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0002 0.00023698806762695 
SELECT * FROM productoffers
                WHERE product_id = '1395' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0002 0.00022506713867188 
SELECT * FROM productoffers
                WHERE product_id = 1395
                ORDER BY price ASC LIMIT 1
140 0.0002 0.000244140625 
SELECT value FROM productattributes
                WHERE product_id = '1395'
                AND name = 'ListPriceAmount'
141 0.0003 0.00025010108947754 
SELECT value FROM productattributes WHERE product_id = '1395' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0003 0.00025200843811035 
SELECT * FROM products WHERE id = '3643'
143 0.0002 0.00023794174194336 
SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
144 0.0003 0.00028395652770996 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
145 0.0004 0.00037097930908203 
SELECT * FROM product_image_select WHERE product_id = '3643'
146 0.0002 0.00019097328186035 
SELECT * FROM productcustomimages WHERE product_id = '3643'
147 0.0003 0.00027918815612793 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3643'
                GROUP BY o.product_id
148 0.0003 0.00031495094299316 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
149 0.0003 0.00027012825012207 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
150 0.0004 0.00044488906860352 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
151 0.0003 0.00025200843811035 
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0003 0.00026392936706543 
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0002 0.00023198127746582 
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00026607513427734 
SELECT value FROM productattributes
                WHERE product_id = '3643'
                AND name = 'ListPriceAmount'
155 0.0003 0.0002751350402832 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3643'
                GROUP BY o.product_id
156 0.0003 0.00033688545227051 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '3643'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
157 0.0003 0.00032901763916016 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
158 0.0003 0.00031781196594238 
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0003 0.0003359317779541 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
160 0.0003 0.00027084350585938 
SELECT * FROM products WHERE id = '1067'
161 0.0002 0.00024104118347168 
SELECT * FROM productimages WHERE product_id = '1067' ORDER BY sortorder ASC
162 0.0004 0.00040102005004883 
SELECT * FROM product_image_select WHERE product_id = '1067'
163 0.0002 0.00020384788513184 
SELECT * FROM productcustomimages WHERE product_id = '1067'
164 0.0006 0.00059700012207031 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1067' AND a.name = n.originalname
165 0.0003 0.00025010108947754 
SELECT * FROM productoffers WHERE product_id = '1067' AND merchantid = 'A1X6FK5RDHNB96'
166 0.0003 0.0002598762512207 
SELECT * FROM productoffers
                WHERE product_id = '1067' AND price > 0
                ORDER BY price ASC LIMIT 1
167 0.0002 0.0002291202545166 
SELECT * FROM productoffers
                WHERE product_id = 1067
                ORDER BY price ASC LIMIT 1
168 0.0002 0.00023913383483887 
SELECT value FROM productattributes
                WHERE product_id = '1067'
                AND name = 'ListPriceAmount'
169 0.0003 0.0002601146697998 
SELECT value FROM productattributes WHERE product_id = '1067' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170 0.0003 0.0002589225769043 
SELECT * FROM products WHERE id = '1277'
171 0.0003 0.00027108192443848 
SELECT * FROM productimages WHERE product_id = '1277' ORDER BY sortorder ASC
172 0.0004 0.00038790702819824 
SELECT * FROM product_image_select WHERE product_id = '1277'
173 0.0002 0.00020003318786621 
SELECT * FROM productcustomimages WHERE product_id = '1277'
174 0.0006 0.00061607360839844 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1277' AND a.name = n.originalname
175 0.0002 0.00024509429931641 
SELECT * FROM productoffers WHERE product_id = '1277' AND merchantid = 'A1X6FK5RDHNB96'
176 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = '1277' AND price > 0
                ORDER BY price ASC LIMIT 1
177 0.0002 0.00022292137145996 
SELECT * FROM productoffers
                WHERE product_id = 1277
                ORDER BY price ASC LIMIT 1
178 0.0002 0.00024890899658203 
SELECT value FROM productattributes
                WHERE product_id = '1277'
                AND name = 'ListPriceAmount'
179 0.0003 0.00026702880859375 
SELECT value FROM productattributes WHERE product_id = '1277' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0003 0.00026917457580566 
SELECT * FROM products WHERE id = '2439'
181 0.0003 0.00025296211242676 
SELECT * FROM productimages WHERE product_id = '2439' ORDER BY sortorder ASC
182 0.0004 0.00037789344787598 
SELECT * FROM product_image_select WHERE product_id = '2439'
183 0.0002 0.00018906593322754 
SELECT * FROM productcustomimages WHERE product_id = '2439'
184 0.0006 0.0005800724029541 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2439' AND a.name = n.originalname
185 0.0002 0.00024008750915527 
SELECT * FROM productoffers WHERE product_id = '2439' AND merchantid = 'A1X6FK5RDHNB96'
186 0.0002 0.00024914741516113 
SELECT * FROM productoffers
                WHERE product_id = '2439' AND price > 0
                ORDER BY price ASC LIMIT 1
187 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = 2439
                ORDER BY price ASC LIMIT 1
188 0.0003 0.00026392936706543 
SELECT value FROM productattributes
                WHERE product_id = '2439'
                AND name = 'ListPriceAmount'
189 0.0003 0.00026202201843262 
SELECT value FROM productattributes WHERE product_id = '2439' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190 0.0003 0.0002589225769043 
SELECT * FROM products WHERE id = '807'
191 0.0003 0.00029397010803223 
SELECT * FROM productimages WHERE product_id = '807' ORDER BY sortorder ASC
192 0.0004 0.00038599967956543 
SELECT * FROM product_image_select WHERE product_id = '807'
193 0.0002 0.00018906593322754 
SELECT * FROM productcustomimages WHERE product_id = '807'
194 0.0005 0.00050115585327148 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '807' AND a.name = n.originalname
195 0.0002 0.00023293495178223 
SELECT * FROM productoffers WHERE product_id = '807' AND merchantid = 'A1X6FK5RDHNB96'
196 0.0002 0.0002288818359375 
SELECT * FROM productoffers
                WHERE product_id = '807' AND price > 0
                ORDER BY price ASC LIMIT 1
197 0.0002 0.0002140998840332 
SELECT * FROM productoffers
                WHERE product_id = 807
                ORDER BY price ASC LIMIT 1
198 0.0002 0.00022602081298828 
SELECT value FROM productattributes
                WHERE product_id = '807'
                AND name = 'ListPriceAmount'
199 0.0003 0.00025606155395508 
SELECT value FROM productattributes WHERE product_id = '807' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0002 0.00024795532226562 
SELECT * FROM products WHERE id = '992'
201 0.0003 0.00025320053100586 
SELECT * FROM productimages WHERE product_id = '992' ORDER BY sortorder ASC
202 0.0005 0.00047993659973145 
SELECT * FROM product_image_select WHERE product_id = '992'
203 0.0002 0.00020885467529297 
SELECT * FROM productcustomimages WHERE product_id = '992'
204 0.0005 0.00046896934509277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '992' AND a.name = n.originalname
205 0.0002 0.00024104118347168 
SELECT * FROM productoffers WHERE product_id = '992' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0003 0.00025701522827148 
SELECT * FROM productoffers
                WHERE product_id = '992' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0003 0.00026893615722656 
SELECT value FROM productattributes WHERE product_id = '992' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0003 0.00026297569274902 
SELECT * FROM products WHERE id = '1134'
209 0.0002 0.0002291202545166 
SELECT * FROM productimages WHERE product_id = '1134' ORDER BY sortorder ASC
210 0.0002 0.0002439022064209 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1134' AND p.id = pi.product_id ORDER BY pi.sortorder
211 0.0004 0.00038480758666992 
SELECT * FROM product_image_select WHERE product_id = '1134'
212 0.0002 0.00019121170043945 
SELECT * FROM productcustomimages WHERE product_id = '1134'
213 0.0003 0.00026893615722656 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1134'
                GROUP BY o.product_id
214 0.0003 0.00028395652770996 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
215 0.0003 0.00027894973754883 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1134
216 0.0005 0.00045084953308105 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1134' AND a.name = n.originalname
217 0.0002 0.00023102760314941 
SELECT * FROM productoffers WHERE product_id = '1134' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0002 0.00023484230041504 
SELECT * FROM productoffers
                WHERE product_id = '1134' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0002 0.00022506713867188 
SELECT * FROM productoffers
                WHERE product_id = 1134
                ORDER BY price ASC LIMIT 1
220 0.0002 0.00024890899658203 
SELECT value FROM productattributes
                WHERE product_id = '1134'
                AND name = 'ListPriceAmount'
221 0.0003 0.00027894973754883 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1134'
                GROUP BY o.product_id
222 0.0003 0.0003049373626709 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1134'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
223 0.0002 0.00024795532226562 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1134
224 0.0003 0.00027298927307129 
SELECT value FROM productattributes WHERE product_id = '1134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225 0.0003 0.0002598762512207 
SELECT * FROM products WHERE parent_id = '1134'
226 0.0003 0.00025296211242676 
SELECT * FROM products WHERE id = '4206'
227 0.0003 0.0002748966217041 
SELECT * FROM productimages WHERE product_id = '4206' ORDER BY sortorder ASC
228 0.0004 0.00036096572875977 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4206' AND p.id = pi.product_id ORDER BY pi.sortorder
229 0.0005 0.00047802925109863 
SELECT * FROM product_image_select WHERE product_id = '4206'
230 0.0002 0.00020313262939453 
SELECT * FROM productcustomimages WHERE product_id = '4206'
231 0.0003 0.00033211708068848 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4206'
                GROUP BY o.product_id
232 0.0004 0.00037002563476562 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4206'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
233 0.0003 0.00034618377685547 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4206
234 0.0004 0.0004420280456543 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4206' AND a.name = n.originalname
235 0.0003 0.00026607513427734 
SELECT * FROM productoffers WHERE product_id = '4206' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0003 0.00029206275939941 
SELECT * FROM productoffers
                WHERE product_id = '4206' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0003 0.00034403800964355 
SELECT * FROM productoffers
                WHERE product_id = 4206
                ORDER BY price ASC LIMIT 1
238 0.0003 0.00029587745666504 
SELECT value FROM productattributes
                WHERE product_id = '4206'
                AND name = 'ListPriceAmount'
239 0.0003 0.00028109550476074 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4206'
                GROUP BY o.product_id
240 0.0004 0.00036001205444336 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4206'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
241 0.0003 0.00026893615722656 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4206
242 0.0003 0.00029087066650391 
SELECT value FROM productattributes WHERE product_id = '4206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0003 0.00034689903259277 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4206'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
244 0.0004 0.00035905838012695 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4206'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
245 0.0003 0.00026679039001465 
SELECT * FROM products WHERE id = '1479'
246 0.0002 0.00024199485778809 
SELECT * FROM productimages WHERE product_id = '1479' ORDER BY sortorder ASC
247 0.0004 0.00040388107299805 
SELECT * FROM product_image_select WHERE product_id = '1479'
248 0.0002 0.00019717216491699 
SELECT * FROM productcustomimages WHERE product_id = '1479'
249 0.0006 0.000640869140625 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1479' AND a.name = n.originalname
250 0.0002 0.00023698806762695 
SELECT * FROM productoffers WHERE product_id = '1479' AND merchantid = 'A1X6FK5RDHNB96'
251 0.0002 0.00023698806762695 
SELECT * FROM productoffers
                WHERE product_id = '1479' AND price > 0
                ORDER BY price ASC LIMIT 1
252 0.0002 0.00023102760314941 
SELECT * FROM productoffers
                WHERE product_id = 1479
                ORDER BY price ASC LIMIT 1
253 0.0003 0.00025010108947754 
SELECT value FROM productattributes
                WHERE product_id = '1479'
                AND name = 'ListPriceAmount'
254 0.0003 0.00027704238891602 
SELECT value FROM productattributes WHERE product_id = '1479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0003 0.00027894973754883 
SELECT * FROM products WHERE id = '859'
256 0.0002 0.00023198127746582 
SELECT * FROM productimages WHERE product_id = '859' ORDER BY sortorder ASC
257 0.0004 0.00039505958557129 
SELECT * FROM product_image_select WHERE product_id = '859'
258 0.0002 0.00020194053649902 
SELECT * FROM productcustomimages WHERE product_id = '859'
259 0.0006 0.00056314468383789 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '859' AND a.name = n.originalname
260 0.0003 0.00028491020202637 
SELECT * FROM productoffers WHERE product_id = '859' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0003 0.00029611587524414 
SELECT * FROM productoffers
                WHERE product_id = '859' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0003 0.00026512145996094 
SELECT * FROM productoffers
                WHERE product_id = 859
                ORDER BY price ASC LIMIT 1
263 0.0003 0.00025796890258789 
SELECT value FROM productattributes
                WHERE product_id = '859'
                AND name = 'ListPriceAmount'
264 0.0003 0.00026392936706543 
SELECT value FROM productattributes WHERE product_id = '859' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265 0.0003 0.00025796890258789 
SELECT * FROM products WHERE id = '4245'
266 0.0002 0.00024294853210449 
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
267 0.0004 0.0003809928894043 
SELECT * FROM product_image_select WHERE product_id = '4245'
268 0.0002 0.00019598007202148 
SELECT * FROM productcustomimages WHERE product_id = '4245'
269 0.0006 0.00055599212646484 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
270 0.0003 0.00027585029602051 
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
271 0.0003 0.00027298927307129 
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
272 0.0003 0.00029492378234863 
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273 0.0003 0.00028896331787109 
SELECT * FROM products WHERE id = '1417'
274 0.0002 0.00024008750915527 
SELECT * FROM productimages WHERE product_id = '1417' ORDER BY sortorder ASC
275 0.0004 0.00038599967956543 
SELECT * FROM product_image_select WHERE product_id = '1417'
276 0.0002 0.00019693374633789 
SELECT * FROM productcustomimages WHERE product_id = '1417'
277 0.0004 0.00043487548828125 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1417' AND a.name = n.originalname
278 0.0003 0.00026798248291016 
SELECT * FROM productoffers WHERE product_id = '1417' AND merchantid = 'A1X6FK5RDHNB96'
279 0.0003 0.00026702880859375 
SELECT * FROM productoffers
                WHERE product_id = '1417' AND price > 0
                ORDER BY price ASC LIMIT 1
280 0.0003 0.00030803680419922 
SELECT value FROM productattributes WHERE product_id = '1417' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281 0.0003 0.0002748966217041 
SELECT * FROM products WHERE id = '977'
282 0.0003 0.00025796890258789 
SELECT * FROM productimages WHERE product_id = '977' ORDER BY sortorder ASC
283 0.0004 0.00038981437683105 
SELECT * FROM product_image_select WHERE product_id = '977'
284 0.0002 0.00021195411682129 
SELECT * FROM productcustomimages WHERE product_id = '977'
285 0.0004 0.00043010711669922 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '977' AND a.name = n.originalname
286 0.0003 0.00025415420532227 
SELECT * FROM productoffers WHERE product_id = '977' AND merchantid = 'A1X6FK5RDHNB96'
287 0.0003 0.00031113624572754 
SELECT * FROM productoffers
                WHERE product_id = '977' AND price > 0
                ORDER BY price ASC LIMIT 1
288 0.0003 0.00027084350585938 
SELECT value FROM productattributes WHERE product_id = '977' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289 0.0003 0.00027203559875488 
SELECT * FROM products WHERE id = '926'
290 0.0003 0.00030183792114258 
SELECT * FROM productimages WHERE product_id = '926' ORDER BY sortorder ASC
291 0.0004 0.00040197372436523 
SELECT * FROM product_image_select WHERE product_id = '926'
292 0.0002 0.00021004676818848 
SELECT * FROM productcustomimages WHERE product_id = '926'
293 0.0006 0.00062990188598633 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '926' AND a.name = n.originalname
294 0.0002 0.0002439022064209 
SELECT * FROM productoffers WHERE product_id = '926' AND merchantid = 'A1X6FK5RDHNB96'
295 0.0002 0.00024199485778809 
SELECT * FROM productoffers
                WHERE product_id = '926' AND price > 0
                ORDER BY price ASC LIMIT 1
296 0.0002 0.00022506713867188 
SELECT * FROM productoffers
                WHERE product_id = 926
                ORDER BY price ASC LIMIT 1
297 0.0002 0.0002439022064209 
SELECT value FROM productattributes
                WHERE product_id = '926'
                AND name = 'ListPriceAmount'
298 0.0003 0.00029397010803223 
SELECT value FROM productattributes WHERE product_id = '926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299 0.0003 0.00026392936706543 
SELECT * FROM products WHERE id = '1065'
300 0.0002 0.00023508071899414 
SELECT * FROM productimages WHERE product_id = '1065' ORDER BY sortorder ASC
301 0.0004 0.00037884712219238 
SELECT * FROM product_image_select WHERE product_id = '1065'
302 0.0002 0.00020194053649902 
SELECT * FROM productcustomimages WHERE product_id = '1065'
303 0.0007 0.00072693824768066 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1065' AND a.name = n.originalname
304 0.0003 0.00025391578674316 
SELECT * FROM productoffers WHERE product_id = '1065' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0002 0.00024509429931641 
SELECT * FROM productoffers
                WHERE product_id = '1065' AND price > 0
                ORDER BY price ASC LIMIT 1
306 0.0002 0.000244140625 
SELECT * FROM productoffers
                WHERE product_id = 1065
                ORDER BY price ASC LIMIT 1
307 0.0003 0.00027990341186523 
SELECT value FROM productattributes
                WHERE product_id = '1065'
                AND name = 'ListPriceAmount'
308 0.0003 0.0002901554107666 
SELECT value FROM productattributes WHERE product_id = '1065' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0003 0.00031709671020508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2689' ORDER BY timestamp DESC
310 0.0002 0.00022006034851074 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1727' ORDER BY timestamp DESC
311 0.0002 0.00020813941955566 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1395' ORDER BY timestamp DESC
312 0.0002 0.00020194053649902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3643' ORDER BY timestamp DESC
313 0.0002 0.00020384788513184 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1067' ORDER BY timestamp DESC
314 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1277' ORDER BY timestamp DESC
315 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2439' ORDER BY timestamp DESC
316 0.0002 0.00019693374633789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '807' ORDER BY timestamp DESC
317 0.0002 0.00019717216491699 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '992' ORDER BY timestamp DESC
318 0.0002 0.00021982192993164 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1134' ORDER BY timestamp DESC
319 0.0002 0.00020480155944824 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4206' ORDER BY timestamp DESC
320 0.0002 0.00020599365234375 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1479' ORDER BY timestamp DESC
321 0.0002 0.00020194053649902 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '859' ORDER BY timestamp DESC
322 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4245' ORDER BY timestamp DESC
323 0.0002 0.00020003318786621 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1417' ORDER BY timestamp DESC
324 0.0002 0.0001978874206543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '977' ORDER BY timestamp DESC
325 0.0002 0.00019216537475586 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '926' ORDER BY timestamp DESC
326 0.0002 0.00019717216491699 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1065' ORDER BY timestamp DESC
327 0.0004 0.00035905838012695 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
328 0.0003 0.00029706954956055 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
329 0.0003 0.0002601146697998 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
330 0.0126 0.012580871582031 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
331 0.0003 0.0003349781036377 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
332 0.0003 0.00026416778564453 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
333 0.0003 0.00027298927307129 
SELECT * FROM products WHERE id = 1626
334 0.0003 0.00028204917907715 
SELECT * FROM products WHERE id = 4041
335 0.0003 0.00028395652770996 
SELECT * FROM products WHERE id = 4312
336 0.0003 0.0002739429473877 
SELECT * FROM products WHERE id = 777
337 0.0003 0.00026202201843262 
SELECT * FROM products WHERE id = 3881
338 0.0002 0.00024199485778809 
SELECT * FROM products WHERE id = 4213
339 0.0003 0.00027298927307129 
SELECT * FROM products WHERE id = '1626'
340 0.0003 0.00025105476379395 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
341 0.0004 0.00037693977355957 
SELECT * FROM product_image_select WHERE product_id = '1626'
342 0.0002 0.00019598007202148 
SELECT * FROM productcustomimages WHERE product_id = '1626'
343 0.0005 0.0004570484161377 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
344 0.0004 0.0003669261932373 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
345 0.0003 0.00026202201843262 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
346 0.0003 0.00030016899108887 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347 0.0003 0.00026702880859375 
SELECT * FROM products WHERE id = '4041'
348 0.0002 0.00024294853210449 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
349 0.0004 0.00040102005004883 
SELECT * FROM product_image_select WHERE product_id = '4041'
350 0.0002 0.00019288063049316 
SELECT * FROM productcustomimages WHERE product_id = '4041'
351 0.0009 0.0008702278137207 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
352 0.0002 0.00023889541625977 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
353 0.0003 0.00025486946105957 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
354 0.0003 0.00028300285339355 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355 0.0003 0.0002589225769043 
SELECT * FROM products WHERE id = '4312'
356 0.0003 0.0002741813659668 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
357 0.0005 0.00048303604125977 
SELECT * FROM product_image_select WHERE product_id = '4312'
358 0.0002 0.0002288818359375 
SELECT * FROM productcustomimages WHERE product_id = '4312'
359 0.0007 0.00073599815368652 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
360 0.0002 0.000244140625 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
361 0.0003 0.00025391578674316 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
362 0.0003 0.00028204917907715 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363 0.0002 0.0002439022064209 
SELECT * FROM products WHERE id = '777'
364 0.0002 0.00023818016052246 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
365 0.0004 0.00037503242492676 
SELECT * FROM product_image_select WHERE product_id = '777'
366 0.0002 0.00019097328186035 
SELECT * FROM productcustomimages WHERE product_id = '777'
367 0.0007 0.00066709518432617 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
368 0.0002 0.00023913383483887 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
369 0.0002 0.00024795532226562 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
370 0.0003 0.00028395652770996 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371 0.0003 0.00028204917907715 
SELECT * FROM products WHERE id = '3881'
372 0.0003 0.00029706954956055 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
373 0.0005 0.00049614906311035 
SELECT * FROM product_image_select WHERE product_id = '3881'
374 0.0003 0.0002598762512207 
SELECT * FROM productcustomimages WHERE product_id = '3881'
375 0.0009 0.00094199180603027 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
376 0.0003 0.00025486946105957 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
377 0.0003 0.00028395652770996 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
378 0.0003 0.00030899047851562 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379 0.0003 0.00026416778564453 
SELECT * FROM products WHERE id = '4213'
380 0.0003 0.00030612945556641 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
381 0.0004 0.00038003921508789 
SELECT * FROM product_image_select WHERE product_id = '4213'
382 0.0002 0.00020003318786621 
SELECT * FROM productcustomimages WHERE product_id = '4213'
383 0.0008 0.00078392028808594 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
384 0.0002 0.00024104118347168 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
385 0.0004 0.00037789344787598 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
386 0.0003 0.00030708312988281 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
387 0.0006 0.00064611434936523 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
388 0.0005 0.00050592422485352 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
389 0.0012 0.0011928081512451 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
390 0.0004 0.00043606758117676 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
391 0.0004 0.00038385391235352 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
392 0.0004 0.00041604042053223 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
393 0.0005 0.00047492980957031 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'